Case Sensitive "WHERE" Clauses? - Mailing list pgsql-sql

Are string comparisons in postgresql case sensitive?

I keep on having this response:

SELECT *
FROM People
WHERE first_name='jordan'

Result: 0 records

SELECT *
FROM People
WHERE first_name='Jordan'

Result: 1 record

I though that string matching in SQL was case-insensitive. Isn't this correct? If not, what workarounds have been used
successfullybefore? Obviously, formatting the search string for the query is not a solution...
 
-- 

Jordan Reiter                          mailto:jordan@breezing.com
Breezing.com                           http://breezing.com
1106 West Main St                      phone:434.295.2050
Charlottesville, VA 22903              fax:603.843.6931